I am attempting to issue a simple SQL statement to an Access97 database. Below is some code from the ActiveX .dll I have created. (The msgboxes are for debugging purposes.) Just after ther msgbox displaying the SQL statement I receive the error.

'Open data source
Dim conn As New ADODB.Connection

'set the connection properties
conn.Properties("Data Source&#34 = "ASPDatabase"
conn.Open

'open recordset
Dim oRS As New ADODB.Recordset
oRS.CursorLocation = adUseServer
oRS.LockType = adLockReadOnly
MsgBox strSQL
oRS.Open strSQL, conn, adOpenForwardOnly, adLockOptimistic
MsgBox "oRS.Open"

I have tried variations of the cursor and lock types, but nothing works. I new to ASP and would appreciate any help with this. I am currently developing with ASP using Microsoft Personal Webserver 4.0 on a Windows 95 machine.

Thank you.